Brands
Ruger

Search Results for: "ruger 10 22 takedown"

The Ruger Store
Shop now

Ruger SR22 22LR Police Trade-In Pistol with Manual Safety

Style: 367-44818
Department: Firearms > Used Gun Collection

Ruger American Rimfire 22WMR Bolt-Action Rifle with Carved American Farmer Stock

Style: 8345
Department: Firearms > Bolt Action Rifles
(1 customer review)

Ruger SR22 22LR Police Trade-In Pistol with Manual Safety (Magazine Not Included)

Style: 367-65059
Department: Firearms > Used Gun Collection

Ruger Mark IV Target 22LR Rimfire Pistol with Bull Barrel

Style: 40159
Department: Firearms > Handgun Semi-Auto

Ruger Blackhawk Bisley Stainless Exclusive 22LR Revolver with Hardwood Grips

Notify Me When Available

Style: 0680
Department: Firearms > Revolvers > Single-Action Revolvers

Ruger Lite Rack LCP II 22LR Rimfire Pistol

Notify Me When Available

Style: 13705
Department: Firearms > Handgun Semi-Auto

WRANGLER 22LR TALO BLUED FINISH WOOD GRIPS

Ruger Wrangler 22 LR Single-Action Revolver with Hardwood Grips and Desantis Holster

Notify Me When Available

Style: 2014
Department: Firearms > Revolvers > Single-Action Revolvers

MARK IV 22LR HUNTER PISTOL WITH FLUTED BARREL

Ruger Mark IV Hunter 22LR Rimfire Pistol with Fluted Barrel

Notify Me When Available

Style: 40177
Department: Firearms > Handgun Semi-Auto

WRANGLER 22LR BIRDSHEAD REVOLVER W/HOLSTER

Ruger Wrangler 22LR Single-Action Revolver with Birdshead Grips and Wild Hog Holster

Notify Me When Available

Style: 2030
Department: Firearms > Revolvers > Single-Action Revolvers

Ruger SR22P 22LR Police Trade-In Pistol with Light/Laser

Style: 366-13060
Department: Firearms > Used Gun Collection

Ruger SR22 22LR Police Trade-In Pistol with Purple Frame

Style: 368-99317
Department: Firearms > Used Gun Collection

MARK III COMPETITION 22LR RIMFIRE PISTOL

Ruger Mark III 22LR Competition Stainless Steel Rimfire Pistol

Style: 10112
Department: Firearms > Handgun Semi-Auto
(1 customer review)

Ruger Mark III 22LR Target Rimfire Pistol with Rail

Style: 10101
Department: Firearms > Handgun Semi-Auto

Ruger American Rimfire Mini Ranch 22LR Bolt-Action Rifle with Burnt Bronze Threaded Ba

Notify Me When Available

Style: 8376
Department: Firearms > Bolt Action Rifles

AMERICAN RIMFIRE TARGET 22 LR THUMBHOLE LAMINATE

Ruger American Rimfire Target 22 LR Bolt-Action Rifle with Thumbhole and Black Laminate Stock

Notify Me When Available

Style: 8366
Department: Firearms > Bolt Action Rifles

Ruger Mark IV Target 22LR Rimfire Pistol with Threaded Barrel

Notify Me When Available

Style: 40178
Department: Firearms > Handgun Semi-Auto
(1 customer review)

Ruger Mark III 22LR Target Stainless Steel Rimfire Pistol

Style: 10103
Department: Firearms > Handgun Semi-Auto

AMERICAN RIFLE 22LR WITH RED FIBER OPTIC

Ruger American Rimfire Rifle 22 LR Standard with Red Fiber Optic

Style: 8302
Department: Firearms > Bolt Action Rifles

< 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 >

Debugging Information

ColdFusion Server Evaluation	2021,0,13,330286
Template	/search.cfm
Time Stamp	20-May-24 03:06 PM
Locale	English (US)
User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP	10.200.2.4
Host Name	10.200.2.4

Execution Time

Total Time	Avg Time	Count	Template
1865 ms	1865 ms	1	E:/inetpub/wwwroot/search.cfm
140 ms	8 ms	18	C:/inetpub/wwwroot/includes/dropship.cfm
4 ms	4 ms	1	E:/inetpub/wwwroot/Application.cfm
3 ms	3 ms	1	E:/inetpub/wwwroot/search_sidenav.cfm
1 ms	1 ms	1	C:/inetpub/wwwroot/includes/newheader.cfm
1 ms	1 ms	1	E:/inetpub/wwwroot/pagethru.cfm
0 ms	0 ms	19	C:/inetpub/wwwroot/includes/brands.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/metatags.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/newfooter.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/security/block_access.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/security/library.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/security/sql_injection.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1869 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

redirects (Datasource=celerantsql, Time=2ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:17.017

select * from tb_mfg_promo.dbo.tb_search_redirect with (nolock) where kword='ruger 10 22 takedown' and kword <> '' and kword is not NULL and site='sportsman'

mysearch (Datasource=celerantsql, Time=856ms, Records=595) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

SELECT distinct a.style_id,
 case a.style_id 
 
 when 114630 then 1 
 when 175816 then 2 
 when 126124 then 3 
 when 176527 then 4 
 when 252355 then 5 
 when 169095 then 6 
 when 266131 then 7 
 when 136937 then 8 
 when 130015 then 9 
 when 128850 then 10 
 when 252479 then 11 
 when 253472 then 12 
 when 175607 then 13 
 when 192502 then 14 
 when 173159 then 15 
 when 168215 then 16 
 when 170670 then 17 
 when 254183 then 18 
 when 138732 then 19 
 when 154855 then 20 
 when 252480 then 21 
 when 266215 then 22 
 when 151649 then 23 
 when 152098 then 24 
 when 254257 then 25 
 when 198182 then 26 
 when 196026 then 27 
 when 267028 then 28 
 when 253370 then 29 
 when 252509 then 30 
 when 252433 then 31 
 when 152464 then 32 
 when 152377 then 33 
 when 168601 then 34 
 when 290893 then 35 
 when 254207 then 36 
 when 290123 then 37 
 when 276114 then 38 
 when 256758 then 39 
 when 170446 then 40 
 when 252510 then 41 
 when 249029 then 42 
 when 44691 then 43 
 when 100321 then 44 
 when 262136 then 45 
 when 279058 then 46 
 when 263431 then 47 
 when 95836 then 48 
 when 181143 then 49 
 when 252508 then 50 
 when 44680 then 51 
 when 44677 then 52 
 when 63789 then 53 
 when 228579 then 54 
 when 152571 then 55 
 when 252434 then 56 
 when 125690 then 57 
 when 81239 then 58 
 when 130260 then 59 
 when 202078 then 60 
 when 181144 then 61 
 when 143739 then 62 
 when 200103 then 63 
 when 246718 then 64 
 when 97312 then 65 
 when 44686 then 66 
 when 163876 then 67 
 when 110809 then 68 
 when 193946 then 69 
 when 252365 then 70 
 when 266214 then 71 
 when 134114 then 72 
 when 225670 then 73 
 when 124257 then 74 
 when 100239 then 75 
 when 94091 then 76 
 when 202785 then 77 
 when 252360 then 78 
 when 136027 then 79 
 when 159148 then 80 
 when 201722 then 81 
 when 111206 then 82 
 when 107577 then 83 
 when 123891 then 84 
 when 44688 then 85 
 when 121162 then 86 
 when 255286 then 87 
 when 168709 then 88 
 when 254239 then 89 
 when 252430 then 90 
 when 221156 then 91 
 when 202351 then 92 
 when 250428 then 93 
 when 201265 then 94 
 when 129498 then 95 
 when 289081 then 96 
 when 291871 then 97 
 when 293040 then 98 
 when 79133 then 99 
 when 285244 then 100 
 when 289119 then 101 
 when 299171 then 102 
 when 201264 then 103 
 when 290621 then 104 
 when 299150 then 105 
 when 294890 then 106 
 when 264060 then 107 
 when 289122 then 108 
 when 291700 then 109 
 when 301138 then 110 
 when 298799 then 111 
 when 298804 then 112 
 when 298795 then 113 
 when 255511 then 114 
 when 289095 then 115 
 when 288138 then 116 
 when 288157 then 117 
 when 298926 then 118 
 when 159332 then 119 
 when 44912 then 120 
 when 44653 then 121 
 when 215615 then 122 
 when 181921 then 123 
 when 69632 then 124 
 when 63875 then 125 
 when 209118 then 126 
 when 192509 then 127 
 when 198746 then 128 
 when 44655 then 129 
 when 155414 then 130 
 when 252432 then 131 
 when 191732 then 132 
 when 1179 then 133 
 when 142925 then 134 
 when 100658 then 135 
 when 252485 then 136 
 when 307908 then 137 
 when 227912 then 138 
 when 139985 then 139 
 when 105153 then 140 
 when 147964 then 141 
 when 301367 then 142 
 when 69320 then 143 
 when 110015 then 144 
 when 97311 then 145 
 when 44697 then 146 
 when 246134 then 147 
 when 30001 then 148 
 when 301364 then 149 
 when 301370 then 150 
 when 173157 then 151 
 when 261494 then 152 
 when 115822 then 153 
 when 283322 then 154 
 when 252357 then 155 
 when 285231 then 156 
 when 134110 then 157 
 when 122521 then 158 
 when 116832 then 159 
 when 182319 then 160 
 when 191324 then 161 
 when 201783 then 162 
 when 245607 then 163 
 when 87211 then 164 
 when 252571 then 165 
 when 44901 then 166 
 when 173263 then 167 
 when 143712 then 168 
 when 159662 then 169 
 when 205234 then 170 
 when 212144 then 171 
 when 210934 then 172 
 when 267654 then 173 
 when 283227 then 174 
 when 300520 then 175 
 when 172664 then 176 
 when 147670 then 177 
 when 246135 then 178 
 when 281683 then 179 
 when 297561 then 180 
 when 57084 then 181 
 when 264457 then 182 
 when 138675 then 183 
 when 242402 then 184 
 when 309735 then 185 
 when 44696 then 186 
 when 252481 then 187 
 when 276350 then 188 
 when 297726 then 189 
 when 300519 then 190 
 when 113334 then 191 
 when 266717 then 192 
 when 11827 then 193 
 when 68142 then 194 
 when 208087 then 195 
 when 266288 then 196 
 when 214142 then 197 
 when 252356 then 198 
 when 248058 then 199 
 when 245411 then 200 
 when 108197 then 201 
 when 122057 then 202 
 when 267632 then 203 
 when 267703 then 204 
 when 310788 then 205 
 when 11735 then 206 
 when 271780 then 207 
 when 252688 then 208 
 when 11823 then 209 
 when 264455 then 210 
 when 218421 then 211 
 when 277897 then 212 
 when 282188 then 213 
 when 302667 then 214 
 when 297736 then 215 
 when 189598 then 216 
 when 296769 then 217 
 when 253028 then 218 
 when 44911 then 219 
 when 266496 then 220 
 when 44921 then 221 
 when 247518 then 222 
 when 279061 then 223 
 when 154640 then 224 
 when 44917 then 225 
 when 202424 then 226 
 when 245409 then 227 
 when 291252 then 228 
 when 192499 then 229 
 when 44903 then 230 
 when 275985 then 231 
 when 306678 then 232 
 when 44652 then 233 
 when 216506 then 234 
 when 175076 then 235 
 when 44656 then 236 
 when 205227 then 237 
 when 173050 then 238 
 when 280517 then 239 
 when 219936 then 240 
 when 280516 then 241 
 when 184154 then 242 
 when 297979 then 243 
 when 192498 then 244 
 when 192500 then 245 
 when 220980 then 246 
 when 266716 then 247 
 when 122979 then 248 
 when 297863 then 249 
 when 111461 then 250 
 when 304972 then 251 
 when 304973 then 252 
 when 304974 then 253 
 when 154963 then 254 
 when 280982 then 255 
 when 225671 then 256 
 when 122404 then 257 
 when 122415 then 258 
 when 133124 then 259 
 when 191785 then 260 
 when 192488 then 261 
 when 303617 then 262 
 when 122763 then 263 
 when 87677 then 264 
 when 168708 then 265 
 when 307907 then 266 
 when 163726 then 267 
 when 201902 then 268 
 when 103201 then 269 
 when 125608 then 270 
 when 247703 then 271 
 when 261803 then 272 
 when 196898 then 273 
 when 123916 then 274 
 when 252416 then 275 
 when 188884 then 276 
 when 292373 then 277 
 when 309697 then 278 
 when 188659 then 279 
 when 44842 then 280 
 when 252461 then 281 
 when 264313 then 282 
 when 213538 then 283 
 when 216998 then 284 
 when 213453 then 285 
 when 44843 then 286 
 when 130232 then 287 
 when 44839 then 288 
 when 218419 then 289 
 when 252516 then 290 
 when 130210 then 291 
 when 245412 then 292 
 when 301238 then 293 
 when 130209 then 294 
 when 247698 then 295 
 when 125598 then 296 
 when 179662 then 297 
 when 218420 then 298 
 when 204886 then 299 
 when 123666 then 300 
 when 118963 then 301 
 when 149701 then 302 
 when 247709 then 303 
 when 44674 then 304 
 when 179690 then 305 
 when 159567 then 306 
 when 217714 then 307 
 when 213912 then 308 
 when 252425 then 309 
 when 256340 then 310 
 when 153094 then 311 
 when 252569 then 312 
 when 299030 then 313 
 when 199112 then 314 
 when 201633 then 315 
 when 290558 then 316 
 when 70580 then 317 
 when 199015 then 318 
 when 213796 then 319 
 when 246100 then 320 
 when 254492 then 321 
 when 273338 then 322 
 when 274428 then 323 
 when 290623 then 324 
 when 290544 then 325 
 when 44844 then 326 
 when 44833 then 327 
 when 181920 then 328 
 when 218054 then 329 
 when 217713 then 330 
 when 267202 then 331 
 when 44835 then 332 
 when 142953 then 333 
 when 168036 then 334 
 when 192948 then 335 
 when 293060 then 336 
 when 253589 then 337 
 when 44837 then 338 
 when 198742 then 339 
 when 219752 then 340 
 when 198816 then 341 
 when 22907 then 342 
 when 290496 then 343 
 when 44836 then 344 
 when 44845 then 345 
 when 107584 then 346 
 when 198817 then 347 
 when 205079 then 348 
 when 195477 then 349 
 when 277932 then 350 
 when 108846 then 351 
 when 126558 then 352 
 when 268946 then 353 
 when 287764 then 354 
 when 170120 then 355 
 when 307193 then 356 
 when 288383 then 357 
 when 47929 then 358 
 when 293068 then 359 
 when 288041 then 360 
 when 290528 then 361 
 when 290571 then 362 
 when 22909 then 363 
 when 261120 then 364 
 when 288132 then 365 
 when 291723 then 366 
 when 141296 then 367 
 when 264149 then 368 
 when 288076 then 369 
 when 198559 then 370 
 when 293077 then 371 
 when 298061 then 372 
 when 73130 then 373 
 when 264164 then 374 
 when 264163 then 375 
 when 288042 then 376 
 when 293007 then 377 
 when 291920 then 378 
 when 298723 then 379 
 when 296559 then 380 
 when 207336 then 381 
 when 285527 then 382 
 when 293069 then 383 
 when 293070 then 384 
 when 293071 then 385 
 when 70471 then 386 
 when 283802 then 387 
 when 290588 then 388 
 when 223133 then 389 
 when 202302 then 390 
 when 250584 then 391 
 when 276159 then 392 
 when 288066 then 393 
 when 274645 then 394 
 when 24665 then 395 
 when 211780 then 396 
 when 4743 then 397 
 when 301106 then 398 
 when 147503 then 399 
 when 118787 then 400 
 when 274644 then 401 
 when 211296 then 402 
 when 245408 then 403 
 when 304942 then 404 
 when 309324 then 405 
 when 255690 then 406 
 when 246233 then 407 
 when 264161 then 408 
 when 251682 then 409 
 when 20103 then 410 
 when 11822 then 411 
 when 59736 then 412 
 when 112140 then 413 
 when 136939 then 414 
 when 141672 then 415 
 when 203897 then 416 
 when 253465 then 417 
 when 176477 then 418 
 when 144446 then 419 
 when 95359 then 420 
 when 38928 then 421 
 when 217044 then 422 
 when 43040 then 423 
 when 246232 then 424 
 when 120896 then 425 
 when 130770 then 426 
 when 144548 then 427 
 when 251683 then 428 
 when 157760 then 429 
 when 199758 then 430 
 when 44757 then 431 
 when 252343 then 432 
 when 247776 then 433 
 when 285802 then 434 
 when 132147 then 435 
 when 170252 then 436 
 when 133830 then 437 
 when 40286 then 438 
 when 44706 then 439 
 when 298071 then 440 
 when 277316 then 441 
 when 102137 then 442 
 when 130219 then 443 
 when 35029 then 444 
 when 199591 then 445 
 when 190017 then 446 
 when 44626 then 447 
 when 255627 then 448 
 when 195559 then 449 
 when 135771 then 450 
 when 114053 then 451 
 when 310314 then 452 
 when 121157 then 453 
 when 277315 then 454 
 when 132529 then 455 
 when 227931 then 456 
 when 88894 then 457 
 when 278419 then 458 
 when 116008 then 459 
 when 177536 then 460 
 when 192875 then 461 
 when 152463 then 462 
 when 214358 then 463 
 when 277318 then 464 
 when 22906 then 465 
 when 61946 then 466 
 when 276646 then 467 
 when 250704 then 468 
 when 277060 then 469 
 when 123902 then 470 
 when 134600 then 471 
 when 252415 then 472 
 when 44915 then 473 
 when 125792 then 474 
 when 208654 then 475 
 when 250133 then 476 
 when 192150 then 477 
 when 192654 then 478 
 when 252478 then 479 
 when 132723 then 480 
 when 262999 then 481 
 when 220615 then 482 
 when 156361 then 483 
 when 152417 then 484 
 when 267296 then 485 
 when 268551 then 486 
 when 291471 then 487 
 when 291324 then 488 
 when 192487 then 489 
 when 204221 then 490 
 when 281141 then 491 
 when 154758 then 492 
 when 137832 then 493 
 when 161446 then 494 
 when 148857 then 495 
 when 151120 then 496 
 when 170637 then 497 
 when 103202 then 498 
 when 175906 then 499 
 when 248407 then 500 
 when 130372 then 501 
 when 207422 then 502 
 when 260562 then 503 
 when 293284 then 504 
 when 297544 then 505 
 when 215600 then 506 
 when 268318 then 507 
 when 232209 then 508 
 when 153403 then 509 
 when 205866 then 510 
 when 291366 then 511 
 when 158550 then 512 
 when 199242 then 513 
 when 213317 then 514 
 when 268541 then 515 
 when 23419 then 516 
 when 245437 then 517 
 when 184317 then 518 
 when 176523 then 519 
 when 251681 then 520 
 when 115126 then 521 
 when 176055 then 522 
 when 44748 then 523 
 when 111160 then 524 
 when 121906 then 525 
 when 206499 then 526 
 when 262299 then 527 
 when 218327 then 528 
 when 170365 then 529 
 when 247857 then 530 
 when 129740 then 531 
 when 257010 then 532 
 when 257066 then 533 
 when 296876 then 534 
 when 136882 then 535 
 when 252550 then 536 
 when 41740 then 537 
 when 272213 then 538 
 when 191994 then 539 
 when 44675 then 540 
 when 246734 then 541 
 when 254005 then 542 
 when 254006 then 543 
 when 104789 then 544 
 when 206498 then 545 
 when 193604 then 546 
 when 213442 then 547 
 when 301145 then 548 
 when 202048 then 549 
 when 205865 then 550 
 when 199545 then 551 
 when 73464 then 552 
 when 248208 then 553 
 when 274039 then 554 
 when 270223 then 555 
 when 46400 then 556 
 when 34627 then 557 
 when 202303 then 558 
 when 274638 then 559 
 when 298407 then 560 
 when 63805 then 561 
 when 21698 then 562 
 when 228037 then 563 
 when 109277 then 564 
 when 159029 then 565 
 when 217712 then 566 
 when 252359 then 567 
 when 268539 then 568 
 when 268588 then 569 
 when 279979 then 570 
 when 46422 then 571 
 when 75189 then 572 
 when 21848 then 573 
 when 266351 then 574 
 when 277880 then 575 
 when 310121 then 576 
 when 113728 then 577 
 when 192506 then 578 
 when 289233 then 579 
 when 9169 then 580 
 when 9170 then 581 
 when 203599 then 582 
 when 309660 then 583 
 when 250724 then 584 
 when 254076 then 585 
 when 149554 then 586 
 when 254075 then 587 
 when 116239 then 588 
 when 75729 then 589 
 when 207423 then 590 
 when 292711 then 591 
 when 164148 then 592 
 when 108713 then 593 
 when 153081 then 594 
 when 199508 then 595 
 when 117780 then 596 
 when 193766 then 597 
 when 278349 then 598 
 when 293002 then 599 
 when 262811 then 600 
 when 210105 then 601 
 when 216788 then 602 
 when 81596 then 603 
 when 208264 then 604 
 when 251723 then 605 
 when 269278 then 606 
 when 121907 then 607 
 when 264517 then 608 
 when 143438 then 609 
 when 217008 then 610 
 when 215826 then 611 
 when 219891 then 612 
 when 307862 then 613 
 when 260563 then 614 
 when 264975 then 615 
 when 277879 then 616 
 when 6313 then 617 
 when 250977 then 618 
 when 262604 then 619 
 when 267861 then 620 
 when 309334 then 621 
 when 21988 then 622 
 when 153070 then 623 
 when 130668 then 624 
 when 114859 then 625 
 when 287449 then 626 
 when 289773 then 627 
 when 281427 then 628 
 when 287063 then 629 
 when 155415 then 630 
 when 275983 then 631 
 when 154937 then 632 
 when 203476 then 633 
 when 247028 then 634 
 when 278424 then 635 
 when 292718 then 636 
 when 171929 then 637 
 when 44657 then 638 
 when 291312 then 639 
 when 291316 then 640 
 when 232631 then 641 
 when 277073 then 642 
 when 287961 then 643 
 when 19033 then 644 
 when 49466 then 645 
 when 303097 then 646 
 when 251173 then 647 
 when 148811 then 648 
 when 260834 then 649 
 when 287061 then 650 
 when 117509 then 651 
 when 118895 then 652 
 when 212824 then 653 
 when 264141 then 654 
 when 309313 then 655 
 when 308273 then 656 
 when 262538 then 657 
 when 98428 then 658 
 when 118829 then 659 
 when 23380 then 660 
 when 232629 then 661 
 when 277037 then 662 
 when 284344 then 663 
 when 141443 then 664 
 when 133827 then 665 
 when 46376 then 666 
 when 216706 then 667 
 when 271577 then 668 
 when 307748 then 669 
 when 271889 then 670 
 when 192167 then 671 
 when 215653 then 672 
 when 268228 then 673 
 when 73227 then 674 
 when 200068 then 675 
 when 46392 then 676 
 when 178616 then 677 
 when 79793 then 678 
 when 278268 then 679 
 when 307676 then 680 
 when 307734 then 681 
 when 286272 then 682 
 when 183620 then 683 
 when 201640 then 684 
 when 223032 then 685 
 when 275986 then 686 
 when 279285 then 687 
 when 281415 then 688 
 when 228059 then 689 
 when 153060 then 690 
 when 48798 then 691 
 when 267463 then 692 
 when 270246 then 693 
 when 262938 then 694 
 when 111009 then 695 
 when 191750 then 696 
 when 214629 then 697 
 when 220935 then 698 
 when 44916 then 699 
 when 287250 then 700 
 when 287062 then 701 
 when 278350 then 702 
 when 201266 then 703 
 when 58993 then 704 
 when 301454 then 705 
 when 125629 then 706 
 when 281647 then 707 
 when 221153 then 708 
 when 280765 then 709 
 when 48802 then 710 
 when 48753 then 711 
 when 75051 then 712 
 when 232438 then 713 
 when 264862 then 714 
 when 281613 then 715 
 when 304884 then 716 
 when 304880 then 717 
 when 304887 then 718 
 when 304882 then 719 
 when 217151 then 720 
 when 306876 then 721 
 when 251342 then 722 
 when 223044 then 723 
 when 275980 then 724 
 when 124007 then 725 
 when 289168 then 726 
 when 291268 then 727 
 when 38025 then 728 
 when 35132 then 729 
 when 46420 then 730 
 when 95319 then 731 
 when 296914 then 732 
 when 228057 then 733 
 when 48752 then 734 
 when 23388 then 735 
 when 255163 then 736 
 when 147786 then 737 
 when 280968 then 738 
 when 301820 then 739 
 when 306875 then 740 
 when 23972 then 741 
 when 206459 then 742 
 when 257137 then 743 
 when 127376 then 744 
 when 227143 then 745 
 when 260608 then 746 
 when 252348 then 747 
 when 252347 then 748 
 when 221997 then 749 
 when 294587 then 750 
 when 7398 then 751 
 when 301491 then 752 
 when 268927 then 753 
 when 203913 then 754 
 when 23550 then 755 
 when 215605 then 756 
 when 228060 then 757 
 when 262568 then 758 
 when 271005 then 759 
 when 303609 then 760 
 when 137833 then 761 
 when 249809 then 762 
 when 201544 then 763 
 when 118893 then 764 
 when 117843 then 765 
 when 178992 then 766 
 when 215535 then 767 
 when 221998 then 768 
 when 7550 then 769 
 when 117844 then 770 
 when 216269 then 771 
 when 282123 then 772 
 when 141249 then 773 
 when 261794 then 774 
 when 287541 then 775 
 when 246555 then 776 
 when 126142 then 777 
 when 181429 then 778 
 when 84398 then 779 
 when 266664 then 780 
 when 286749 then 781 
 when 288588 then 782 
 when 289702 then 783 
 when 225694 then 784 
 when 221151 then 785 
 when 7680 then 786 
 when 216268 then 787 
 when 268037 then 788 
 when 266663 then 789 
 when 281593 then 790 
 when 297541 then 791 
 when 281594 then 792 
 when 128651 then 793 
 when 206959 then 794 
 when 193859 then 795 
 when 266757 then 796 
 when 278253 then 797 
 when 215619 then 798 
 when 208723 then 799 
 when 19093 then 800 
 when 266665 then 801 
 when 225336 then 802 
 when 227930 then 803 
 when 279441 then 804 
 when 279454 then 805 
 when 220956 then 806 
 when 93893 then 807 
 when 308253 then 808 
 when 309483 then 809 
 when 310156 then 810 
 when 309696 then 811 
 when 269259 then 812 
 when 124215 then 813 
 when 252016 then 814 
 when 306715 then 815 
 when 225951 then 816 
 when 249873 then 817 
 when 175670 then 818 
 when 214264 then 819 
 when 196296 then 820 
 when 212010 then 821 
 when 292495 then 822 
 when 228053 then 823 
 when 262324 then 824 
 when 123161 then 825 
 when 134696 then 826 
 when 93752 then 827 
 when 44766 then 828 
 when 44756 then 829 
 when 170124 then 830 
 when 269101 then 831 
 when 147945 then 832 
 when 44933 then 833 
 when 310155 then 834 
 when 252345 then 835 
 when 297820 then 836 
 when 310398 then 837 
 when 213020 then 838 
 when 124218 then 839 
 when 110828 then 840 
 when 176040 then 841 
 when 299397 then 842 
 when 205222 then 843 
 when 105451 then 844 
 when 302657 then 845 
 when 296877 then 846 
 when 278392 then 847 
 when 289232 then 848 
 when 97871 then 849 
 when 85877 then 850 
 when 209767 then 851 
 when 222484 then 852 
 when 260979 then 853 
 when 264145 then 854 
 when 173188 then 855 
 when 262611 then 856 
 when 287539 then 857 
 when 293033 then 858 
 when 218326 then 859 
 when 269451 then 860 
 when 44774 then 861 
 when 193227 then 862 
 when 301272 then 863 
 when 288889 then 864 
 when 307009 then 865 
 when 137831 then 866 
 when 309610 then 867 
 when 44705 then 868 
 when 44629 then 869 
 when 58368 then 870 
 when 307906 then 871 
 when 152327 then 872 
 when 44773 then 873 
 when 300881 then 874 
 when 301490 then 875 
 when 310153 then 876 
 when 44708 then 877 
 when 264142 then 878 
 when 262257 then 879 
 when 199005 then 880 
 when 217383 then 881 
 when 254373 then 882 
 when 270247 then 883 
 when 148856 then 884 
 when 137809 then 885 
 when 117476 then 886 
 when 264888 then 887 
 when 225815 then 888 
 when 225819 then 889 
 when 301109 then 890 
 when 269642 then 891 
 when 302828 then 892 
 when 283970 then 893 
 when 297543 then 894 
 when 310154 then 895 
 when 100613 then 896 
 when 294620 then 897 
 when 305544 then 898 
 when 148056 then 899 
 when 198450 then 900 
 when 290180 then 901 
 when 309482 then 902 
 when 287445 then 903 
 when 262111 then 904 
 when 289798 then 905 
 when 266102 then 906 
 when 263642 then 907 
 when 108339 then 908 
 when 301610 then 909 
 when 264676 then 910 
 when 278395 then 911 
 when 292471 then 912 
 when 287446 then 913 
 when 214121 then 914 
 when 245441 then 915 
 when 283625 then 916 
 when 307521 then 917 
 when 296572 then 918 
 when 198319 then 919 
 when 296690 then 920 
 when 169384 then 921 
 when 307986 then 922 
 when 291543 then 923 
 when 192503 then 924 
 when 254922 then 925 
 when 307192 then 926 
 when 297806 then 927 
 when 302518 then 928 
 when 287527 then 929 
 when 297824 then 930 
 when 266397 then 931 
 when 307194 then 932 
 when 152458 then 933 
 when 246117 then 934 
 when 28121 then 935 
 when 296912 then 936 
 when 272735 then 937 
 when 138206 then 938 
 when 252517 then 939 
 when 279283 then 940 
 when 264461 then 941 
 when 264459 then 942 
 when 286851 then 943 
 when 279431 then 944 
 when 279445 then 945 
 when 291269 then 946 
 when 302656 then 947 
 when 253398 then 948 
 when 264458 then 949 
 when 203906 then 950 
 when 137834 then 951 
 when 127444 then 952 
 when 301611 then 953 
 when 289876 then 954 
 when 296913 then 955 
 when 252431 then 956 
 when 24646 then 957 
 when 252366 then 958 
 when 213589 then 959 
 when 252896 then 960 
 when 24667 then 961 
 when 84712 then 962 
 when 99972 then 963 
 when 267273 then 964 
 when 203911 then 965 
 when 225340 then 966 
 when 152532 then 967 
 when 121924 then 968 
 when 24742 then 969 
 when 44782 then 970 
 when 104864 then 971 
 when 24666 then 972 
 when 24517 then 973 
 when 205075 then 974 
 when 24698 then 975 
 when 273498 then 976 
 when 46340 then 977 
 when 252472 then 978 
 when 126077 then 979 
 when 43039 then 980 
 when 298841 then 981 
 when 147502 then 982 
 when 122648 then 983 
 when 227148 then 984 
 when 216281 then 985 
 when 41470 then 986 
 when 188660 then 987 
 when 176399 then 988 
 when 135272 then 989 
 when 116011 then 990 
 when 252455 then 991 
 when 252344 then 992 
 when 277975 then 993 
 when 13368 then 994 
 when 38932 then 995 
 when 36624 then 996 
 when 266601 then 997 
 when 283800 then 998 
 when 155342 then 999 
 when 129242 then 1000 
 else 1000 
 
 end as ranking,
 
 
 
 max(a.non_invt) as non_invt,sum(qoh + qc) as available,max(a.dept) as dept,max(a.brand) as brand,max(a.of3) as of3,case when sum(qoh + qc) > 0 then 1 else 0 end as instock
 FROM web_all_products a WITH (NOLOCK)
 INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
 INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id and c.store_id=10)
 INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
 INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
 where a.style_id in (114630,175816,126124,176527,252355,169095,266131,136937,130015,128850,252479,253472,175607,192502,173159,168215,170670,254183,138732,154855,252480,266215,151649,152098,254257,198182,196026,267028,253370,252509,252433,152464,152377,168601,290893,254207,290123,276114,256758,170446,252510,249029,44691,100321,262136,279058,263431,95836,181143,252508,44680,44677,63789,228579,152571,252434,125690,81239,130260,202078,181144,143739,200103,246718,97312,44686,163876,110809,193946,252365,266214,134114,225670,124257,100239,94091,202785,252360,136027,159148,201722,111206,107577,123891,44688,121162,255286,168709,254239,252430,221156,202351,250428,201265,129498,289081,291871,293040,79133,285244,289119,299171,201264,290621,299150,294890,264060,289122,291700,301138,298799,298804,298795,255511,289095,288138,288157,298926,159332,44912,44653,215615,181921,69632,63875,209118,192509,198746,44655,155414,252432,191732,1179,142925,100658,252485,307908,227912,139985,105153,147964,301367,69320,110015,97311,44697,246134,30001,301364,301370,173157,261494,115822,283322,252357,285231,134110,122521,116832,182319,191324,201783,245607,87211,252571,44901,173263,143712,159662,205234,212144,210934,267654,283227,300520,172664,147670,246135,281683,297561,57084,264457,138675,242402,309735,44696,252481,276350,297726,300519,113334,266717,11827,68142,208087,266288,214142,252356,248058,245411,108197,122057,267632,267703,310788,11735,271780,252688,11823,264455,218421,277897,282188,302667,297736,189598,296769,253028,44911,266496,44921,247518,279061,154640,44917,202424,245409,291252,192499,44903,275985,306678,44652,216506,175076,44656,205227,173050,280517,219936,280516,184154,297979,192498,192500,220980,266716,122979,297863,111461,304972,304973,304974,154963,280982,225671,122404,122415,133124,191785,192488,303617,122763,87677,168708,307907,163726,201902,103201,125608,247703,261803,196898,123916,252416,188884,292373,309697,188659,44842,252461,264313,213538,216998,213453,44843,130232,44839,218419,252516,130210,245412,301238,130209,247698,125598,179662,218420,204886,123666,118963,149701,247709,44674,179690,159567,217714,213912,252425,256340,153094,252569,299030,199112,201633,290558,70580,199015,213796,246100,254492,273338,274428,290623,290544,44844,44833,181920,218054,217713,267202,44835,142953,168036,192948,293060,253589,44837,198742,219752,198816,22907,290496,44836,44845,107584,198817,205079,195477,277932,108846,126558,268946,287764,170120,307193,288383,47929,293068,288041,290528,290571,22909,261120,288132,291723,141296,264149,288076,198559,293077,298061,73130,264164,264163,288042,293007,291920,298723,296559,207336,285527,293069,293070,293071,70471,283802,290588,223133,202302,250584,276159,288066,274645,24665,211780,4743,301106,147503,118787,274644,211296,245408,304942,309324,255690,246233,264161,251682,20103,11822,59736,112140,136939,141672,203897,253465,176477,144446,95359,38928,217044,43040,246232,120896,130770,144548,251683,157760,199758,44757,252343,247776,285802,132147,170252,133830,40286,44706,298071,277316,102137,130219,35029,199591,190017,44626,255627,195559,135771,114053,310314,121157,277315,132529,227931,88894,278419,116008,177536,192875,152463,214358,277318,22906,61946,276646,250704,277060,123902,134600,252415,44915,125792,208654,250133,192150,192654,252478,132723,262999,220615,156361,152417,267296,268551,291471,291324,192487,204221,281141,154758,137832,161446,148857,151120,170637,103202,175906,248407,130372,207422,260562,293284,297544,215600,268318,232209,153403,205866,291366,158550,199242,213317,268541,23419,245437,184317,176523,251681,115126,176055,44748,111160,121906,206499,262299,218327,170365,247857,129740,257010,257066,296876,136882,252550,41740,272213,191994,44675,246734,254005,254006,104789,206498,193604,213442,301145,202048,205865,199545,73464,248208,274039,270223,46400,34627,202303,274638,298407,63805,21698,228037,109277,159029,217712,252359,268539,268588,279979,46422,75189,21848,266351,277880,310121,113728,192506,289233,9169,9170,203599,309660,250724,254076,149554,254075,116239,75729,207423,292711,164148,108713,153081,199508,117780,193766,278349,293002,262811,210105,216788,81596,208264,251723,269278,121907,264517,143438,217008,215826,219891,307862,260563,264975,277879,6313,250977,262604,267861,309334,21988,153070,130668,114859,287449,289773,281427,287063,155415,275983,154937,203476,247028,278424,292718,171929,44657,291312,291316,232631,277073,287961,19033,49466,303097,251173,148811,260834,287061,117509,118895,212824,264141,309313,308273,262538,98428,118829,23380,232629,277037,284344,141443,133827,46376,216706,271577,307748,271889,192167,215653,268228,73227,200068,46392,178616,79793,278268,307676,307734,286272,183620,201640,223032,275986,279285,281415,228059,153060,48798,267463,270246,262938,111009,191750,214629,220935,44916,287250,287062,278350,201266,58993,301454,125629,281647,221153,280765,48802,48753,75051,232438,264862,281613,304884,304880,304887,304882,217151,306876,251342,223044,275980,124007,289168,291268,38025,35132,46420,95319,296914,228057,48752,23388,255163,147786,280968,301820,306875,23972,206459,257137,127376,227143,260608,252348,252347,221997,294587,7398,301491,268927,203913,23550,215605,228060,262568,271005,303609,137833,249809,201544,118893,117843,178992,215535,221998,7550,117844,216269,282123,141249,261794,287541,246555,126142,181429,84398,266664,286749,288588,289702,225694,221151,7680,216268,268037,266663,281593,297541,281594,128651,206959,193859,266757,278253,215619,208723,19093,266665,225336,227930,279441,279454,220956,93893,308253,309483,310156,309696,269259,124215,252016,306715,225951,249873,175670,214264,196296,212010,292495,228053,262324,123161,134696,93752,44766,44756,170124,269101,147945,44933,310155,252345,297820,310398,213020,124218,110828,176040,299397,205222,105451,302657,296877,278392,289232,97871,85877,209767,222484,260979,264145,173188,262611,287539,293033,218326,269451,44774,193227,301272,288889,307009,137831,309610,44705,44629,58368,307906,152327,44773,300881,301490,310153,44708,264142,262257,199005,217383,254373,270247,148856,137809,117476,264888,225815,225819,301109,269642,302828,283970,297543,310154,100613,294620,305544,148056,198450,290180,309482,287445,262111,289798,266102,263642,108339,301610,264676,278395,292471,287446,214121,245441,283625,307521,296572,198319,296690,169384,307986,291543,192503,254922,307192,297806,302518,287527,297824,266397,307194,152458,246117,28121,296912,272735,138206,252517,279283,264461,264459,286851,279431,279445,291269,302656,253398,264458,203906,137834,127444,301611,289876,296913,252431,24646,252366,213589,252896,24667,84712,99972,267273,203911,225340,152532,121924,24742,44782,104864,24666,24517,205075,24698,273498,46340,252472,126077,43039,298841,147502,122648,227148,216281,41470,188660,176399,135272,116011,252455,252344,277975,13368,38932,36624,266601,283800,155342,129242)
 
 
  and ltrim(rtrim(lower(a.brand))) = 'ruger'
 
 group by a.style_id 
  order by  instock desc, ranking asc

getSideDepts (Datasource=, Time=1ms, Records=5) in E:\inetpub\wwwroot\search_sidenav.cfm @ 15:06:18.018

select distinct dept from mysearch where dept <> 'EMPTY'
  order by dept asc

getSideBrands (Datasource=, Time=1ms, Records=1) in E:\inetpub\wwwroot\search_sidenav.cfm @ 15:06:18.018

select distinct brand from mysearch
  order by brand asc

getSideCaliber (Datasource=, Time=1ms, Records=40) in E:\inetpub\wwwroot\search_sidenav.cfm @ 15:06:18.018

select distinct of3 from mysearch
  order by of3 asc

GetProducts (Datasource=celerantsql, Time=27ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =299030 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=7ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=299030 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=7ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 299030 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:18.018

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 299030 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 299030

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Used Gun Collection' and subtyp_1='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=2ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * from tb_product_reviews 
												where style_id=299030  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=299030
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=3ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =199112 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=2ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=199112 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 199112 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=2ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:18.018

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 199112 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 199112

get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Bolt Action Rifles' and subtyp_1='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=3ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * from tb_product_reviews 
												where style_id=199112  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=199112
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=27ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =290558 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=290558 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=7ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 290558 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=2ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:18.018

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 290558 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 290558

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Used Gun Collection' and subtyp_1='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=3ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * from tb_product_reviews 
												where style_id=290558  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=290558
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=27ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =199015 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=199015 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 199015 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=2ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:18.018

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 199015 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 199015

get_web_url (Datasource=celerantsql, Time=2ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=3ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * from tb_product_reviews 
												where style_id=199015  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=199015
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=26ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =213796 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=7ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=213796 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 213796 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=17ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:18.018

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 213796 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 213796

get_web_url (Datasource=celerantsql, Time=2ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Revolvers' and subtyp_1='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select web_url, subtyp_1 from tb_web_taxonomy where dept = 'Firearms' and typ='Revolvers' and subtyp_1='Single-Action Revolvers' and subtyp_2='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=4ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * from tb_product_reviews 
												where style_id=213796  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=213796
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=25ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =246100 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=5ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=246100 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=7ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 246100 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:18.018

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 246100 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 246100

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=2ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * from tb_product_reviews 
												where style_id=246100  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=246100
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=26ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =254492 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=254492 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 254492 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=15ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:18.018

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 254492 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 254492

get_web_url (Datasource=celerantsql, Time=2ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Revolvers' and subtyp_1='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select web_url, subtyp_1 from tb_web_taxonomy where dept = 'Firearms' and typ='Revolvers' and subtyp_1='Single-Action Revolvers' and subtyp_2='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=2ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * from tb_product_reviews 
												where style_id=254492  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=2ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=254492
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=24ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =273338 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=273338 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=7ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 273338 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=14ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:18.018

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 273338 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 273338

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=2ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * from tb_product_reviews 
												where style_id=273338  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=2ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=273338
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=25ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =274428 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=274428 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=7ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 274428 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:18.018

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 274428 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 274428

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Revolvers' and subtyp_1='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select web_url, subtyp_1 from tb_web_taxonomy where dept = 'Firearms' and typ='Revolvers' and subtyp_1='Single-Action Revolvers' and subtyp_2='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=3ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * from tb_product_reviews 
												where style_id=274428  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=274428
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=25ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =290623 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=290623 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 290623 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:18.018

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 290623 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 290623

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Used Gun Collection' and subtyp_1='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=6ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * from tb_product_reviews 
												where style_id=290623  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=290623
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=2ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =290544 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=290544 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=3ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 290544 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=2ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:18.018

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 290544 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 290544

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Used Gun Collection' and subtyp_1='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * from tb_product_reviews 
												where style_id=290544  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=290544
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=28ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =44844 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=44844 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 44844 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=3ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:18.018

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 44844 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 44844

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=3ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select * from tb_product_reviews 
												where style_id=44844  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=44844
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=26ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:18.018

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =44833 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=7ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=44833 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=5ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 44833 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=5ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:19.019

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 44833 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 44833

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=2ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select * from tb_product_reviews 
												where style_id=44833  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=2ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=44833
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=26ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =218054 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=5ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=218054 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 218054 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=2ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:19.019

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 218054 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 218054

get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Bolt Action Rifles' and subtyp_1='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=3ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select * from tb_product_reviews 
												where style_id=218054  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=218054
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=25ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =217713 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=217713 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 217713 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=2ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:19.019

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 217713 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 217713

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Bolt Action Rifles' and subtyp_1='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=3ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select * from tb_product_reviews 
												where style_id=217713  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=2ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=217713
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=24ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =267202 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=7ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=267202 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 267202 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=2ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:19.019

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 267202 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 267202

get_web_url (Datasource=celerantsql, Time=2ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=3ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select * from tb_product_reviews 
												where style_id=267202  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=267202
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=25ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =44835 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=7ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=44835 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 44835 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=2ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:19.019

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 44835 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 44835

get_web_url (Datasource=celerantsql, Time=2ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=2ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=3ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select * from tb_product_reviews 
												where style_id=44835  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=44835
												and status='A' 
												and site = 'sportsman'

GetProducts (Datasource=celerantsql, Time=24ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =142953 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

GetPrice (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=142953 and e.store_id =10 group by a.style_id order by a.style_id

check_qoh (Datasource=celerantsql, Time=6ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 142953 and e.store_id = 10 
											group by a.style_id, e.qc

check_ss_qoh (Datasource=celerantsql, Time=1ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 15:06:19.019

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 142953 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = BERETTA

			    
			        Parameter #2(cf_sql_varchar) = GLOCK

			    
			        Parameter #3(cf_sql_varchar) = RUGER

			    
			        Parameter #4(cf_sql_varchar) = SMITH AND WESSON

			    
			        Parameter #5(cf_sql_varchar) = LEUPOLD

			    
			        Parameter #6(cf_sql_varchar) = SPRINGFIELD

			    
			        Parameter #7(cf_sql_varchar) = THOMPSON CENTER

			    
			        Parameter #8(cf_sql_varchar) = TIKKA

			    
			        Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 142953

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

Select distinct * from tb_web_taxonomy where dept = 'Firearms' and typ='EMPTY' and site = 'sportsman'

get_web_url (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

Select web_url, typ from tb_web_taxonomy where dept = 'Firearms' and typ='Bolt Action Rifles' and subtyp_1='EMPTY' and site = 'sportsman'

get_reviews (Datasource=celerantsql, Time=3ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select * from tb_product_reviews 
												where style_id=142953  
												and status='A' and site = 'sportsman'

get_reviews_average (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 15:06:19.019

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=142953
												and status='A' 
												and site = 'sportsman'

Scope Variables

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\inetpub\images\
logdir=E:\inetpub\logs
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\search.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=fikker-KEPi-Z7Xa=BsBSbwRLNOhAxs6UKNM9KWTshGBARUhu; fikker-2ITi-jkXI=4enQXwhGlJjmPkfWL9j3di8QM5h9hgJJ; CFGLOBALS=urltoken%3DCFID%23%3D11221%26CFTOKEN%23%3D574367dbb7f234a6%2DE9F8C47B%2DB9FD%2D27DF%2D4DE957F881A39CAA%23lastvisit%3D%7Bts%20%272024%2D05%2D20%2015%3A06%3A16%27%7D%23hitcount%3D3%23timecreated%3D%7Bts%20%272024%2D05%2D20%2015%3A06%3A14%27%7D%23cftoken%3D574367dbb7f234a6%2DE9F8C47B%2DB9FD%2D27DF%2D4DE957F881A39CAA%23cfid%3D11221%23; CFID=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-11221; CFTOKEN=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-574367dbb7f234a6-E9F8C47B-B9FD-27DF-4DE957F881A39CAA; FIRST_NAME=; LAST_NAME=; USERNAME=; EMAIL=; PASSWORD=; CUSTOMER_ID=
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/search.cfm/CurrentPage/21/kword/ruger%2010%2022%20takedown/brand/ruger
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=/CurrentPage/21/kword/ruger 10 22 takedown/brand/ruger
PATH_TRANSLATED=E:\inetpub\wwwroot\search.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/search.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=11221
cftoken=574367dbb7f234a6-E9F8C47B-B9FD-27DF-4DE957F881A39CAA
hitcount=3
lastvisit={ts '2024-05-20 15:06:16'}
timecreated={ts '2024-05-20 15:06:14'}
urltoken=CFID=11221&CFTOKEN=574367dbb7f234a6-E9F8C47B-B9FD-27DF-4DE957F881A39CAA

Cookie Variables:
CFGLOBALS=urltoken=CFID#=11221&CFTOKEN#=574367dbb7f234a6-E9F8C47B-B9FD-27DF-4DE957F881A39CAA#lastvisit={ts '2024-05-20 15:06:16'}#hitcount=3#timecreated={ts '2024-05-20 15:06:14'}#cftoken=574367dbb7f234a6-E9F8C47B-B9FD-27DF-4DE957F881A39CAA#cfid=11221#
CFID=11221
CFTOKEN=574367dbb7f234a6-E9F8C47B-B9FD-27DF-4DE957F881A39CAA
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
USERNAME=
fikker-2ITi-jkXI=4enQXwhGlJjmPkfWL9j3di8QM5h9hgJJ
fikker-KEPi-Z7Xa=BsBSbwRLNOhAxs6UKNM9KWTshGBARUhu

Form Fields:
KWORD=ruger 10 22 takedown
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=11221
cftoken=574367dbb7f234a6-E9F8C47B-B9FD-27DF-4DE957F881A39CAA
cs=/category.cfm/sportsman/ankle-holsters-for-sale/make/hi-point/model/max-9
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_11221_574367dbb7f234a6-E9F8C47B-B9FD-27DF-4DE957F881A39CAA
strarray=Array (0)
urltoken=CFID=11221&CFTOKEN=574367dbb7f234a6-E9F8C47B-B9FD-27DF-4DE957F881A39CAA

URL Parameters:
CLEARANCE=
CurrentPage=21
DEPT=
DISPLAYCOUNT=18
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF3=
OF4=
OF5=
OF6=
ORDER_BY=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SPORTSMAN=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WHATSNEW=
brand=ruger
kword=ruger 10 22 takedown

Debug Rendering Time: 10 ms

Department

Brands

Search Results for: "ruger 10 22 takedown"